package cn.com.api.mapper.base;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.*;

import cn.com.api.entity.ApiT_member_point;

//DAO
public interface T_member_pointMapperBase {

	// 根据id查看
	@Select("SELECT * FROM t_member_point  WHERE id = #{id}")
	public ApiT_member_point findT_member_pointById(Integer id);

	// 查看数据集
	@Select("SELECT * FROM T_member_point")
	public List<ApiT_member_point> findT_member_points();

	// 添加
	@Insert("INSERT INTO t_member_point (member_id, point, change_point, consume_point, addtime, expiretime, reason, remark, related_id, type, operator) VALUES (#{member_id}, #{point}, #{change_point}, #{consume_point}, #{addtime}, #{expiretime}, #{reason}, #{remark}, #{related_id}, #{type}, #{operator})")
	@Options(useGeneratedKeys = true, keyProperty = "id")
	public int insertT_member_point(ApiT_member_point t_member_point);

	// 修改
	@Update("UPDATE t_member_point SET member_id = #{member_id}, point = #{point}, change_point = #{change_point}, consume_point = #{consume_point}, addtime = #{addtime}, expiretime = #{expiretime}, reason = #{reason}, remark = #{remark}, related_id = #{related_id}, type = #{type}, operator = #{operator} WHERE id = #{id}")
	public int updateT_member_point(ApiT_member_point t_member_point);

	// 删除
	@Delete("DELETE FROM t_member_point  WHERE id = #{id}")
	public int deleteT_member_point(Integer id);

	// Foreign keys revelant

	// region Indexs revelant

}
